SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[DISC_CDS_RequestInsert]
	@OID nvarchar(50),
	@DistID varchar(50),
	@Identifier varchar(50),
	@CodesRequested int,
	@RequestDate datetime,
	@ExpDate datetime,
	@UserID int
AS
BEGIN
	INSERT INTO dbo.[DnnProduct_CDS_Requests]
	(
		OID,
		DistributorID,
		Identifier,
		CodesRequested,
		RequestDate,
		ExpDate,
		UserID
	)
	VALUES
	(
		@OID,
		@DistID,
		@Identifier,
		@CodesRequested,
		@RequestDate,
		@ExpDate,
		@UserID
	)
	
	SELECT SCOPE_IDENTITY()
END
GO
